CREATE TABLE [dbo].[Invoice_Lines]
(
[REFERENCE_NUM] [int] NOT NULL CONSTRAINT [DF_Invoice_Lines_REFERENCE_NUM] DEFAULT ((0)),
[LINE_NUM] [int] NOT NULL CONSTRAINT [DF_Invoice_Lines_LINE_NUM] DEFAULT ((0)),
[ST_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Invoice_Lines_ST_ID] DEFAULT (''),
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Invoice_Lines_PRODUCT_CODE] DEFAULT (''),
[CHARGES] [money] NOT NULL CONSTRAINT [DF_Invoice_Lines_CHARGES] DEFAULT ((0)),
[BILL_FROM] [datetime] NULL,
[BILL_THRU] [datetime] NULL,
[BILL_QTY] [int] NOT NULL CONSTRAINT [DF_Invoice_Lines_BILL_QTY] DEFAULT ((0)),
[CREDITS] [money] NOT NULL CONSTRAINT [DF_Invoice_Lines_CREDITS] DEFAULT ((0)),
[PAID_FROM] [datetime] NULL,
[PAID_THRU] [datetime] NULL,
[PAID_QTY] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Invoice_Lines_PAID_QTY] DEFAULT ((0)),
[BALANCE] [money] NOT NULL CONSTRAINT [DF_Invoice_Lines_BALANCE] DEFAULT ((0)),
[ORG_CODE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Invoice_Lines_ORG_CODE] DEFAULT (''),
[AR_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Invoice_Lines_AR_ACCOUNT] DEFAULT (''),
[ADJUSTMENTS] [money] NOT NULL CONSTRAINT [DF_Invoice_Lines_ADJUSTMENTS] DEFAULT ((0)),
[IS_FR_ITEM] [bit] NOT NULL CONSTRAINT [DF_Invoice_Lines_IS_FR_ITEM] DEFAULT ((0)),
[CAMPAIGN_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Invoice_Lines_CAMPAIGN_CODE] DEFAULT (''),
[APPEAL_CODE] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Invoice_Lines_APPEAL_CODE] DEFAULT (''),
[FAIR_MARKET_VALUE] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Invoice_Lines_FAIR_MARKET_VALUE] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
CREATE NONCLUSTERED INDEX [iInvoice_LinesREFERENCE_NUM] ON [dbo].[Invoice_Lines] ([REFERENCE_NUM]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Invoice_Lines] TO [IMIS]
GRANT SELECT ON  [dbo].[Invoice_Lines] TO [IMIS]
GRANT INSERT ON  [dbo].[Invoice_Lines] TO [IMIS]
GRANT DELETE ON  [dbo].[Invoice_Lines] TO [IMIS]
GRANT UPDATE ON  [dbo].[Invoice_Lines] TO [IMIS]
GO